MSIS EXCEL PRACTICE QUIZ
The order of operations in Math, which Excel follows, is?
() ^ * / + -
If you have columns that are truncating your content (not showing all the content), but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to:
Click Wrap text
Which is not the function of "Edit, Clear" command?
Delete cells
How do you know a range is active?
Two of the above are correct.
In order to multiply items in Excel you would use_____.
*
What is the result of the following formula: =8+(7/(2+5)^2-1/7)*3?
*
What is the result of the following formula? =27/3+5-2^3+ (17-8)/3^2
7
What is the result of the following formula: =(5-3)^2/1*2?
8
A formula begins with:
=
If cells are: A1=90, A2=85, A3=80, A4=75, and A5=75. What will be your formula if you are going to get the average?
=AVERAGE(A1:A5)
A Range in Microsoft 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 is the function of the 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
Which of the following is not a valid data type in Excel?
Character
A fast way to add up this column of numbers is to click in 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.
Which of the following is one way to change column width to fit the contents?
Double-click the boundary to the right of the column heading.
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
There are three worksheets with every new workbook. You can change that automatic number if you want to.
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
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
Which 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
To select several cells or ranges that are not touching each other, you would _____ while selecting.
Hold down the CTRL key
Labels are aligned at the ________ edge of the cell.
Left
The name of the active cell appears in the ___________.
Name box
On an Excel sheet the active cell is indicated by ____.
None of the above
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
To sort data in an Excel worksheet you can use the ______.
Sort A to Z and Sort Z to A buttons
Which formula can add the 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.
=FUNCTION(argument1,argument2, ...) is ________.
The general syntax of all functions.
What happens when dollar signs ($) are entered in this address, $B$2:$B$10?
The range address is absolute.
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 function and then moves inward.
True
If you choose a larger font size, the height of the row is automatically made taller.
True
A_______ is a group of cells that form a rectangle on the screen.
Two of the above are correct
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
An Excel Workbook is a collection of _______.
Worksheets
Is it possible to insert 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 data is to be changed to edit.
