Excel
Adding __________ around calculations indicates which calculations should be performed first before following the typical order of operations
( )
To give a table a new name select the table and perform the following steps
Table tools. Design. Properties. Table name
What's the Default format for Excel workbook files
.xlsx
Which function what do you use to find the average of totals in cells c1through c5
=AVERAGE(C1:C5)
What is the correct formula to add the values in cells A1 and B1
=SUM(A1+B1)
You would like the cell reference in a formula to remain the same when you copy it from sell A9 to sell B9. This is called a _______ reference
Absolute
Misspelled words in excel
Aren't automatically flagged
You just started excelling would like to open a new spreadsheet what should you select
Blank workbook
Which of the following is an example of a cell reference
C6
Selecting ________ Allows you to remove a hyperlink from a cell while maintaining the cell formatting
Clear hyperlinks
On a spreadsheet what runs vertically and is identified with letters
Columns
You should select the chart ________ Button to remove a series title from a chart
Filter
Which type of chart would use to quickly show a connection between sales growth over a five-year period
Line
What would be a situation in which you could use an Excel chart to present your data
Listing soccer team members with their address info- wrong
Which feature could use to automatically shade sails containing a negative value in red
Conditional formatting
You would like to remove the conditional formatting from a range of cells after selecting the range, you should press ________ To open the formatting tab and remove the conditional formatting
Ctrl + Q
Which key removes all data from an active sell with one click
Delete
Your pointer becomes a __________ When you point to the column boundary
Double headed arrow
Which key should you press to change the cell contents to your type data
Enter
Press the _______ Key to move to the next cell in a row
Tab
The mathematical order of operations is used in excel one formulas are evaluated. This order of operations states the order to be
Exponentiation, multiplication and division, addition and subtraction
You can __________ To keep one area of a worksheet static why are you scroll to a different area within the same worksheet
Freeze panes
Which function should be used to display a value based on comparisons
IF
When you see ##### in a cell, you should
Increase cell width
With quicksort you can sort data in a range by
Individual column
On the Excel ribbon, select the data tab in the sort and filter group and then select the sort button to conduct a ______ sort
Multiple column
You would like to add an additional spreadsheet to your workbook which button should you select
New sheet
Which contextual tab appears when you select an image that has been added to a worksheet
Picture tools format
The __________ button automatically Displays next to the data when you select a range of numerical data which is available option for creating a chart
Quick analysis
To quickly create a chart from a select a range of numeric data you can select
Quick analysis
Which feature of the Excel window displays the contents of an active cell
Ribbon bar
To make your spreadsheet data easier to read number should be
Right aligned
The data selected to create a table must include
Row headers- wrong
You would like to print all the contents of a work sheet on two pages. Selecting ________ allows you to select the number of pages you want your work sheet to print on
Scale to fit
Small charts within cells that are useful for displaying data trends are
Sparklines
What's the default total row function
Subtotal
What does it mean when #DIV/0! Is displayed in a green triangle is added to the upper left-hand corner of a cell
The formula can't be calculated because there's an error
Which font style would compete with a cell border
Underline
A ___________ refers to an entire Excel file
Workbook
To add exponentiation to a formula, use the __________ Symbol
^