
Week 2 - Quiz
Quiz
•
Business
•
University
•
Practice Problem
•
Easy
Tien Tran
Used 1+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What is the formula to add values in cells A1, B1, and C1?
=A1 + B1 - C1
=A1 - B1 + C1
=A1 + B1 + C1
=A1 - B1 - C1
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What is the function will achieve the same result of A1+B1+C1?
=SUM(A1:C1)
=SUMIF(A1:C1)
=COUNT(A1:C1)
=COUNTIF(A1:C1)
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Cell E11 contains the formula =SUM(E1:E10). How is the formula adjusted when a new row is inserted above row 5?
=SUM(E1:E11)
=SUM(E1:E10)
=SUM(E1:E12)
=SUM(E1:E13)
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What is the formula to count the number of numeric values in the range A1:A30?
=SUM(A1:A30)
=COUNT(A1:A30)
=COUNTA(A1:A30)
=SUMIF(A1:A30)
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
To combine multiple cells into one combined cell, which of the following do you use?
Column Width command
Center button
Merge and Center button
Increase Ident button
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following conditional formatting options can you use to highlight the top 10 values in a range of cells?
Icon Sets
Color Scales
Data Bars
Highlight Cells Rules
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.
reverse
transpose
fill
merge
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
Popular Resources on Wayground
10 questions
Forest Self-Management
Lesson
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
30 questions
Thanksgiving Trivia
Quiz
•
9th - 12th Grade
30 questions
Thanksgiving Trivia
Quiz
•
6th Grade
11 questions
Would You Rather - Thanksgiving
Lesson
•
KG - 12th Grade
48 questions
The Eagle Way
Quiz
•
6th Grade
10 questions
Identifying equations
Quiz
•
KG - University
10 questions
Thanksgiving
Lesson
•
5th - 7th Grade
