MSIS Basic Excel Exam
The order of operations in math, which Excel follows, is?
()^*/+-
In order to multiply items in Excel you would use
*
To select several cells or ranges that are not touching each other, you would _____ while selecting
Hold down the CTRL key.
A formula begins with:
=
What will be your formula if you want the average of a group of cells?
=AVERAGE(formula)
A Range in Excel refers to......
A group of cells
The first cell in EXCEL worksheet is labeled as _________.
A1
An example of a range is
A1:B3
What happens when dollar signs are entered in this address: $B$2:$B$10?
An absolute cell address is created
What is the function of Autofit?
Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font
In Excel, you can sum a large range of data by simply selecting a tool button called _______?
Autosum
In "=SUM(number1 [,number2][,number3], ....]) number 1, number 2, and number 3 may be numbers or ____________.
Cell references
What is not a valid date type in Excel?
Character
A fast way to add up this column of numbers is to click the cell below the numbers and then......
Click the AutoSum button on the Standard toolbar, then press enter
If you want to paste a formula result, but not the underlying formula, to another cell, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?
Click the arrow on the Paste button on the Standard toolbar, then click Values
On an Excel sheet the active cell is indicated by ____.
Dark wide border
Which is not the function of "Edit, Clear" command?
Delete cells
What is one way to change column width to fit the contents?
Double-click the boundary to the right of the
You can complete the entry of a cell formula that contains cell references by pressing ______.
Enter key
A formula and a function are the same thing
False
To add a new row, click a cell in the row immediately above where you want the new row, right click, select insert and press enter.
False
To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs.
False
There are three worksheets with every new workbook. You can change that automatic number if you want to.
False, there's only two worksheets.
What is represented by the small, black square in the lower-right corner of an active cell or range?
Fill handle
Which button allows you to copy cell formats from one cell to another?
Format Painter
What area in an Excel window allows entering values and formulas?
Formula Bar
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ______.
G10:B1
How do you know a range is active?
It has a bold solid line around it.
Labels are aligned at the ________ edge of the cell.
Left
The number of the active cell appears in the ___________.
Name box
A ________ is a group of cells that form a rectangle on the screen.
Range
Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?
Ribbon
What are the tabs that appear at the bottom of each worksheet called?
Sheet tabs
To sort data in an Excel worksheet you can use the ______.
Sort A to Z and Sort Z to A buttons.
What formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Sum
"#####" in a cell means ...
The cell is not wide enough
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.
True
Formatting data only changes the appearance of data, it does not affect the data itself.
True
If a formula contains several nested functions, Excel starts with the outermost and then moves inward.
True
If you choose a larger font size, the height of the row is automatically made taller.
True
If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:
Type the data in A1 and merge cells A1:E1, then center text
Which menu option can be used to split windows into two?
View --> Split
A _______ is a grid with labeled columns and rows?
Worksheet
Is it possible to inset a jpeg image from a file into an Excel spreadsheet?
Yes
Once data is entered into a cell, can it be edited after saving the file?
Yes, even after saving the file, double click on the cell where the data is to be changed to edit.
=FUNCTION(argument1,argument2, ...) is ________.
the general syntax of all functions
An Excel Workbook is a collection of _______.
worksheets
