COMPUTER SCIENCE QUESTIONS AND ANSWERS PART – 8

1
IN EXCEL, WHAT DOES "B7" REFER TO?
2
WHERE DO YOU CREATE HEADERS AND FOOTERS?
3
WHAT SINGLE CHARACTER SHOULD PRECEDE ALL FORMULAS IN
EXCEL?
4
WHAT IS WRONG IF A CELL SHOWS A SERIES OF #########
5
HOW CAN YOU CHANGE THE WIDTH OF A COLUMN TO BEST FIT THE
CONTENTS OF THAT COLUMN?
6
WHICH OF THE FOLLOWING IS AN EXAMPLE OF AN ABSOLUTE CELL
REFERENCE?
7
WHAT MATHEMATICAL FUNCTION IS USED TO ADD NUMBERS IN A
RANGE OF CELLS?
8
WHICH STATEMENT BEST DESCRIBES A RELATIVE REFERENCE?
9
ONCE A CHART IS CREATED, YOU CAN NOT CHANGE THE CHART STYLE
10
YOU CAN ONLY ALIGN TEXT IN A CELL TO THE LEFT OR RIGHT
11
WHICH KEYS ARE USED TO MOVE FROM CELL TO CELL IN A
WORKSHEET?
12
HOW DO YOU RENAME A WORKSHEET TAB?
13
WHERE DO YOU CHANGE THE MARGINS AND ORIENTATION OF A PAGE?
14
WHICH KEY DO YOU HOLD DOWN TO SELECT A CONTINUOUS RANGE
OF CELLS?
15
WHICH KEY DO YOU HOLD DOWN TO SELECT A NON-CONTINUOUS
RANGE OF CELLS?
16
YOU CAN NOT ADD ADDITIONAL DATA TO AN EXISTING CHART.
17
WHICH OF THE FOLLOWING IS A CORRECT REPRESENTATION OF A
FORMULA?
18
WHERE IS THE FORMULA BAR LOCATED?
19
YOU CAN SAVE A FILE TO ANY DRIVE OR FOLDER FROM THE SAVE/SAVE
AS DIALOGUE BOX.
20
YOU CAN HAVE A MAXIMUM OF 16 WORKSHEETS IN A WORKBOOK.
21
WHICH COMBINATION COULD BE USED TO MOVE A CELL'S CONTENTS
TO ANOTHER AREA ON A WORKSHEET?
22
BORDERS CAN ONLY BE PLACED AT THE BOTTOM OF A CELL
23
WHICH OF THE FOLLOWING IS NOT A CHARACTER FORMATTING
OPTION?
24
YOU NEED TO SELECT A CELL BEFORE APPLYING CHARACTER
FORMATTING?
25
WHEN YOU FORMAT A NUMBER AS CURRENCY, THERE IS NO NEED TO
TYPE IN THE COMMAS WHEN ENTERING THE DATA.
26
YOU CAN INSERT THE FOLLOWING INTO WORKSHEET:
27
WHEN TYPING INFORMATION INTO A CELL, YOU SHOULD BE AWARE OF
THE THREE MODES OF OPERATION WHICH ARE:
28
HOW DO YOU DISPLAY ADDITIONAL TOOLBARS?
29
WHICH OF THE FOLLOWING IS NOT A WAY TO DELETE A WORKSHEET?
30
YOU HAVE A LARGE SPREADSHEET WITH A DATABASE OF
INFORMATION: COLUMN HEADINGS IN A1:F1 AND DATA IN 300 ROWS.
THIS INFORMATION PRINTS ONTO 3 OR MORE PAGES. HOW CAN YOU BE
SURE THAT THE COLUMN HEADINGS ARE ON EACH PAGE?
31
YOU MUST HIGHLIGHT CELLS ON A SHEET AND SET A PRINT AREA
BEFORE PRINTING?
32
WHICH KEY STROKE COMBINATION ALLOWS YOU TO CLOSE MULTIPLE
EXCEL WORKBOOKS?

1
THE SORT COMMAND CAN BE FOUND IN WHICH MENU?
2
YOU CAN ONLY SORT A LIST BY ONE COLUMN
3
WHAT FEATURE CAN BE USED TO DISPLAY A SUBSET OF DATA IN A LIST
BY DISPLAYING ONY THOSE ROWS THAT MEET A SPECIFIC CONDITION?
4
WHAT DO YOU HAVE TO CREATE BEFORE YOU CAN EXECUTE AN
ADVANCED FILTER?
5
WHAT ARE THE FOUR AREAS YOU CAN USE TO ARRANGE DATA IN A
PIVOT TABLE?
6
WHAT CHANGES CAN BE MADE TO A PIVOT TABLE AFTER IT HAS BEEN
CREATED?
7
WHICH OF THE FOLLOWING IS TRUE FOR CELLS THAT ARE LINKED?
8
IF CELL A1 CONTAINS THE FOLLOWING FORMULA: =JANUARY!C6, WHAT
DOES THAT MEAN?
9
WHAT COMMAND CAN BE USED TO LINK CELLS?
10
WHICH OF THE FOLLOWING PROTECTION DOES EXCEL PROVIDE?
11
LOCKING CELLS OR HIDING FORMULAS HAS NO EFFECT UNLESS YOU
PROTECT THE WORKSHEET.
12
WHAT ARE THE TWO TYPES OF PASSWORD OPTIONS YOU CAN USE TO
PROTECT A WORKBOOK?
13
PASSWORDS ARE NOT CASE-SENSITIVE
14
WHAT IS THE FIRST ARGUMENT IN THE IF FUNCTION?
15
IF FUNCTIONS CAN BE NESTED WITHIN ONE ANOTHER
16
WHAT FUNCTION CAN BE COMBINED WITH THE IF FUNCTION TO
ESTABLISH MULTIPLE CONDITIONS FOR THE LOGICAL TEST?
17
WHICH OF THE FOLLOWING CHART TYPES CAN YOU CREATE IN EXCEL?
18
HOW DO YU ACTIVATE A CHART IN ORDER TO MODIFY IT'S CONTENTS
(LIKE CHANGING THE CHART TYPE OR FORMATTING THE DATA SERIES)?

excel 2000
1
What would you click on to center a worksheet on a page?
2
What is the default paper size?
3
Which keys are used to move from cell to cell in a worksheet?
4
In Excel, What does B7 refer to?
5
When you format a number as currency, there is no need to type in the commas when
entering the data.
6
To insert page numbering at the top of every page, you would do the following.
7
You can insert the following into a worksheet:
8
How can you print just the cells that you have selected?
9
What is wrong if a cell shows a series of #######?
10
Excel automatically inserts a page break in a worksheet.
11
To print column and row titles on multiple pages, you would
12
By default, the gridlines that create the cells in a worksheet do not print.
13
By default, how many rows and columns are there in one worksheet?
14
How many times can you click on undo in a worksheet (while getting results)?
15
Excel provides a find feature that allows you to look for specific data and either replace it
with nothing or replace it with other data.
16
You would find the sort Ascending and sort Descending Buttons (Icons) under what
toolbar?
17
The page break preview is found under the worksheet menu bar under file.
18
You can hide and unhide a worksheet in a workbook.
19
You can not spell check in a worksheet.
20
To set the print area, you need to do the following: