NEW
Font size
WorksheetsThird Form Excel Test #1
Total questions: 55
Worksheet time: 34mins
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
An Excel file format extension is
doc
xls
txt
mp3
The numbers in Excel represent the...
Rows
Columns
Cells
Data
When creating a chart in Excel, what is the first thing you need to do?
Select the data to be graphed.
Select the Insert Tab
Choose a chart from the ribbon
Double click the active cell
To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.
&
=
#
*
What function adds all of the numbers in a range of cells?
Calculate
Compute
Sum
Max
To sort data in Excel, go to the __________ ribbon.
Home
Data
Insert
View
What does the mouse look like in a spreadsheet?
Arrow
Pointer
Two headed arrow
Selection cross
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
In Excel, columns are labeled by
Letters
Numbers
Letters and numbers
Excel refers to files as
Databases
Workbook
Document
Where rows and columns meet are referred to as
Cells
Blocks
Boxes
To allow you to evenly distribute a title over a table of numbers, use the
Center button
Merge and center button
If you see a series of "######" in a cell, that means the following:
Row height is too high
Column width is not wide enough
Cells are identified by
Column Letter followed by their Row Number
Row Number followed by their Column Letter
Adding two cells,
A1+A3=SUM
SUM(_)
=SUM(A1+A3)
Total
An arrow in bottom-right corner ot a group on the ribbon tells you that which of the following is available?
list of worksheets
dialog box
A single spreadsheet within a workbook that consists of rows, columns, and cells are called:
Range
Worksheet
Cell
Workbook
A group of adjacent cells, which can be selected and formatted together is called:
Worksheet
Workbook
Cell
Range
A customizable toolbar that provides quick access to frequently used commands is called:
Name box
Ribbon
Quick Access Toolbar
Chart
What function is used to find the lowest grade?
average
sum
min
max
What function was used to find the highest grade?
average
min
sum
max
In a Grade sheet what function would you use to count all students who scored higher than 70%?
counta
countif
count
countblank
SUM, AVERAGE, IF, MIN and MAX are examples of _______.
user-defined functions
online functions
table functions
predefined functions
Any formula used within the table are seen on the __________
cells
cell reference
name box
formula bar
The function COUNT is specific for ___________
counting aall cells
counting all numbers
counting populated cells
counting tables
To sort names in a worksheet, we can use this button.
In the calculating GPA activity, to display the Letter Grade Equivalent, we used the ___ function.
if
count
average
sum
What is this icon?
Sum
AutoSum
Insert Function
Object
What is this icon?
Sum
AutoSum
Insert Function
Object
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
Which of the following methods cannot be used to enter data in a cell
a. Pressing an arrow key
b. Pressing the Tab key
c. Pressing the Esc key
d. Clicking on the formula bar
When a label is too long to fit within a worksheet cell, you typically must
a. Shorten the label
b. Increase the column width
c. Decrease the column width
d. Adjust the row height
The advantage of using a spreadsheet is:
A. calculations can be done automatically.
B. changing data automatically updates calculations
C. more flexibility
D. All of the above
What is the icon for Microsoft Excel?
What do you call the blank boxes on a excel sheet
cell
info
Squares
Spots
How do you make a cell into the active cell
Cells are always active
Click INSERT Cell
Click on the Cell
Click the ACTIVE button
What is the name of this Cell ?
6B
A5
6A
B6
What is the formula sign for multiply?
/
*
=
-
You want to enter a series of numbers down a column. what would be the best tool for the job?
Find & replace
Autofill/Replicate
Cut & Paste
Spelling Checker
Here in Excel, Which button will you select to calculate total marks ?
Explain the difference between merging cells and centering cells in Excel.
Merging cells and centering cells have the same function in Excel.
Merging cells aligns content within a cell, while centering cells combines cells into one.
Merging cells splits cells into two, while centering cells aligns content within a cell.
Merging cells combines cells into one, while centering cells aligns content within a cell.
How can you sort data in Excel based on multiple criteria?
Apply conditional formatting to the data to automatically sort based on multiple criteria
Manually copy and paste the data into separate sheets and sort each sheet individually
Use the 'Sort' feature in Excel and add multiple sorting criteria by clicking on 'Add Level' after specifying each criterion.
Use the 'Filter' feature in Excel to sort based on multiple criteria
Explain the importance of data validation in Excel and provide an example.
Data validation in Excel is unnecessary and slows down the process
Data validation in Excel is important to maintain data integrity, accuracy, and consistency by setting specific criteria for the data entered.
Data validation in Excel is only applicable to advanced users
Data validation in Excel is only important for aesthetic purposes
What is the purpose of the SUMIF function in Excel?
To format cells based on specific criteria
To sum values based on a single criteria
To calculate the average of a range of values
To find the maximum value in a range
How can you create a pivot table in Excel to summarize data from a large dataset?
Select dataset, go to Insert tab, click PivotTable, choose data range, place pivot table, drag fields to rows/columns/values.
Copy data, paste into a new sheet, manually calculate summary, create a table, format as pivot table.
Right-click on data, select Create PivotTable, choose data range, place pivot table, manually input fields to rows/columns/values.
Select data, go to Home tab, click on PivotTable, choose random data range, place pivot table, drag fields to rows/columns/values.
What is the primary purpose of Conditional Formatting in Excel?
To sort data alphabetically
To automatically change the formatting of cells based on set conditions
To create pivot tables for data analysis
What is the purpose of the 'Format Painter' tool in Excel?
Copies formulas from one cell to another
Copies formatting from one cell to another
Adjusts the column width automatically
What is Excel?
Excel is primarily known as software which allows you to create and work with electronic books.
Excel offers a robust set of features to help you achieve goals.
Microsoft Excel is a powerful tool that has become the main instrument for professional data analysis.
You accidentally erased a record in the sheet. What command can be used to restore it immediately?
A. Insert
B. Copy
C. Undo
D. Replace
By default the text data is________ aligned in cell.
Left
Center
Right
Bottom
