Aspire IT Experts
Advance_Excel
1 / 50
You can use the drag and drop method to
2 / 50
you can use the formula palette to
3 / 50
Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a differene cell
4 / 50
When the formula bar is activated, you can see
5 / 50
What happens if you remove the check mark from Row & Column headers on Options dialog box?
6 / 50
A ….. is a group of cells that form a rectangle on the screen.
7 / 50
Each excel file is called a workbook because
8 / 50
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
9 / 50
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
10 / 50
A function inside another function is called a ….. function
11 / 50
The auto calculate feature
12 / 50
a fast way to add up this column of number is to click in the cell below the numbers and then:
13 / 50
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
14 / 50
which do you press to enter the current date in a cell?
15 / 50
Which of the following will not set text in selected cells to italics?
16 / 50
You can create hyperlinks from the Excel workbook to
17 / 50
What function displays row data in a column or column data in a row?
18 / 50
To drag a selected range of data to another worksheet in the same workbook, use the
19 / 50
Which function converts miles to kilometers, kilograms to pounds, and so on?
20 / 50
You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
21 / 50
To copy cell contents using drag and drop, press the
22 / 50
By default the cell pointer moves down when you press Enter. From where can you change this setting?
23 / 50
Which of the following is not an option in the spelling dialog box?
24 / 50
Tab scroll buttons are place on Excel screen
25 / 50
The advantage of using a spreadsheet is:
26 / 50
You can print only an embedded chart by
27 / 50
Documentations should include
28 / 50
Which of the cell pointer indicates that you can fill series?
29 / 50
If you press ……, the cell accepts your typing as its contents.
30 / 50
The default font used in Excel is
31 / 50
To select an individual data marker or data label, you must
32 / 50
Which of the following can not be hidden from Tools >> Options then View tab?
33 / 50
The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is……
34 / 50
You can select a single range of cells by
35 / 50
You can use the formula pallette to
36 / 50
You can copy cell formats from one cell to another by using the
37 / 50
The accounting style shows negative numbers in
38 / 50
It is acceptable to let long text flow into adjacent cells on a worksheet when
39 / 50
To balance your checkbook in Excel, your best method is
40 / 50
To edit data in an embedded Excel worksheet object in a Word document
41 / 50
To open an existing workbook, you can click the Open button on the …… toolbar.
42 / 50
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed
43 / 50
What happens when you press Ctrl + X after selecting some cells in Excel?
44 / 50
To name a constant, you use the …… dialog box
45 / 50
You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
46 / 50
Which of the following is a correct order of precedence in a formula calculation?
47 / 50
Rounding errors can occur
48 / 50
To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
49 / 50
which of the following special function keys allow the content in cell
50 / 50
The minimum and maximum value you can set for Save AutoRecovery Info in Excel are
Your score is
