WorksheetsExcel Advanced
Total questions: 26
Worksheet time: 13mins
Name
Class
Date
1.
All Formulas in Excel must start with:
a)
# sign
b)
@ sign
c)
+ sign
d)
= sign
2.
To Open a new blank workbook
a)
CTRL+S
b)
CTRL+N
c)
CTRL+O
d)
CTRL+P
3.
On the ------------tab, in the Sparklines group, click the type of sparkline that you want to create
a)
Insert
b)
Data
c)
View
d)
Formulas
4.
What is the correct option to edit a formula in a cell?
a)
F2
b)
F4
c)
CTRL+2
d)
CTRL+G
5.
What is the correct option to open up the Find and Replace window?
a)
ALT+H+FD+R
b)
CTRL+F
c)
ALT+H+R
d)
ALT+H+FD+F
6.
What is the keyboard shortcut key to lock cell references in a formula?
a)
CTRL
b)
ALT
c)
F2
d)
F4
7.
Which tab of the ribbon should you go to for removing gridlines on a worksheet?
a)
Page Layout
b)
View
c)
Review
d)
Developer
8.
Under which function we can combine the first and last name
a)
CONCATENATE
b)
Copy and club both in one cell
c)
Flash Fill
d)
SUMIF
9.
Fill in with red every income higher than 70 using which conditional formatting
a)
Color Scales
b)
Top/Bottom Rules
c)
Icon Sets
d)
Highlight Cells Rules
10.
Excel probably considers the cell entry January 1, 2000 to be a
a)
Label
b)
Value
c)
Formula
d)
Text string
11.
When a label is too long to fit within a worksheet cell, you typically must:
a)
Shorten the label
b)
Decrease the column width
c)
Increase the column width
d)
Adjust the row height
12.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column
d)
Hold down the Ctrl key as you click anywhere in the column
13.
Which of the following will not cut information?
a)
Pressing Ctrl + C
b)
Selecting Edit>Cut from the menu
c)
Clicking the Cut button on the standard
d)
Pressing Ctrl+X
14.
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
a)
Click Subtotals on the Data menu.
b)
View the sum in the formula bar.
c)
Click the AutoSum button on the Standard toolbar, then press ENTER.
d)
Enter the formula
15.
Which key do you press to group two or more nonadjacent worksheets?
a)
CTRL
b)
SHIFT
c)
ALT
d)
Fn
16.
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
a)
Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
b)
Right click on the spreadsheet tab and select DELETE
c)
Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
17.
Which formula can add all the numeric values in a range of cells and place the result in a different cell?
a)
Count
b)
Average
c)
Sum
d)
Max
18.
In order to multiple items in Excel you would use:
a)
^
b)
@
c)
*
d)
#
19.
The formula = ((A2+B5)*5% is valid.
a)
true
b)
false
20.
The number of rows in an Excel 2007 worksheet is:
a)
65536
b)
256
c)
64536
d)
1048576
21.
An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.
a)
true
b)
false
22.
You can create maximum one Excel table in a worksheet
a)
true
b)
false
23.
A Function is?
a)
A symbol that represents a specific action
b)
A way of arranging data in a particular order
c)
A built-in formula in Excel
24.
What is a Chart?
a)
It is a visual way to display and compare data
b)
A way of arranging data in a particular order
c)
A calculation that describes the relationship between cells
25.
In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?
a)
Formula returns the value "DONE"
b)
Formula will show an error
c)
Formula returns the value "RESTART"
d)
Formula returns the value "YES"
26.
The most efficient way to format several cells with a specific font, number format, alignment, font color would be to:
a)
Use Format Painter
b)
Format each element using the Toolbar
c)
Select all and use the Formatting dialog box
d)
Apply a table style
100 %
