WorksheetsMicrosoft Excel
Total questions: 25
Worksheet time: 13mins
What kind of software of Microsoft Excel?
Database software
Word processing software
Presentation software
Spreadsheet software
The letters in Excel represent the...
rows
columns
cells
data
The numbers in Excel represent the...
rows
columns
cells
format
File format extension for Excel.
docx
xlsx
txt
pptx
How do you change column width to fit the contents?
Single click the boundary to the left of the column heading
Press ALT and single click anywhere in the column
Double click the boundary to the right of the column heading
Press CTRL ALT DEL
What is the name given to the intersection of a row and column in a spreadsheet?
Cell
Block
Cube
Square
Using the keyboard, you could navigate from cell to another cell by using the...
Enter key
Arrow keys
Piano keys
Tab keys
Home key
Where is the Zoom function is located in Excel?
Bottom right of the spreadsheet document
Bottom left of spreadsheet document
Top right of spreadsheet document
Top left of spreadsheet document
Which icon represent the alignment of text at the top, middle or bottom of a cell?
What is this icon for ?
Zoom
Sort and filter
Symbol
Merge and center
The cell address of the highlighted cell is
C
4
A4
C4
The highlighted box known as
workbooks
worksheets
formula bar
cell
Name the bar where information appears as your input data.
File bar
Formula bar
Help bar
Windows bar
Excel files referred as
Presentations
Databases
Workbooks
Documents
When creating a chart in Excel, what is the first step?
Select the data to be graphed
Select the Insert Tab
Choose a chart from the ribbon
Double click to active cell
Entering a formula and not a text type a(n) ________ preceding the formula.
&
=
#
*
What function adds all of the numbers in a range of cells?
Calculate
Sum
Compute
Max
What is the cell in the worksheet in which you can type data?
Main cell
Active cell
Open cell
Absolute cell
Pie graph is a visual representation of what?
What I like to eat for the holidays
Comparisons of different types of data
Parts that make up a whole
Represent piece of tabulate data
Find an average of cells A1 through A25, which formula would use?
=average(A1:A25)
=avg(A1:A25)
=average(A1.A25)
=avg(A1.A25)
The ability to quickly add a formula, set of number, months or day of the week down a column or across a row.
Autofill
Copy and paste
Drag and drop
Typing
Which of the following methods cannot be used to enter data in a cell?
Pressing on arrow key
Pressing the Tab key
Pressing the Esc key
Clicking on the formula bar
Which of the following will not cut information?
Pressing CTRL + C
Selecting Edit > Cut from the menu
Clicking the Cut button on the standard
Pressing CTRL + X
When a label is too long to fit within worksheet cell, you typically MUST
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
What is the shortcut key to hide entire column?
CTRL + -
CTRL + 0
CTRL + H
CTRL + C
