Worksheets1/10/25 Quiz
Total questions: 28
Worksheet time: 21mins
Name
Class
Date
1.
OS X Cheetah
a)
The twenty-first and current major release of Apple's macOS operating system, the successor to macOS Sonoma.
b)
The first major release and version of macOS, Apple's desktop and server operating system and is the successor to Mac OS 9.
c)
The fifth major release of macOS, Apple's desktop and server operating system for Mac computers and is the successor to Mac OS X Panther.
d)
The seventeenth release of macOS, Apple Inc.'s operating system for Macintosh computers, and is the successor to macOS Catalina.
2.
OS X Jaguar
a)
The third major release of macOS, Apple's desktop and server operating system. Jaguar was the first Mac OS X release to publicly use its code name in marketing and advertisements.
b)
The twenty-first and current major release of Apple's macOS operating system, the successor to macOS Sonoma.
c)
The tenth major release of macOS, Apple Inc.'s desktop and server operating system for Macintosh computers and is the successor to OS X El Capitan.
d)
The fifth major release of macOS, Apple's desktop and server operating system for Mac computers and is the successor to Mac OS X Panther.
3.
OS X Tiger
a)
The third major release of macOS, Apple's desktop and server operating system. Jaguar was the first Mac OS X release to publicly use its code name in marketing and advertisements.
b)
The tenth major release of macOS, Apple Inc.'s desktop and server operating system for Macintosh computers and is the successor to OS X El Capitan.
c)
The fifth major release of macOS, Apple's desktop and server operating system for Mac computers and is the successor to Mac OS X Panther.
d)
The thirteenth major release of macOS, Apple Inc.'s desktop and server operating system for Macintosh computers and is the successor to OS X Mountain Lion.
4.
OS X Mavericks
a)
The thirteenth major release of macOS, Apple Inc.'s desktop and server operating system for Macintosh computers and is the successor to OS X Mountain Lion.
b)
The nineteenth major release of macOS, Apple Inc.'s operating system for Macintosh computers, and is the successor to macOS Monterey.
c)
The tenth major release of macOS, Apple Inc.'s desktop and server operating system for Macintosh computers and is the successor to OS X El Capitan.
d)
The twenty-first and current major release of Apple's macOS operating system, the successor to macOS Sonoma.
5.
macOS Sierra
a)
The fifth major release of macOS, Apple's desktop and server operating system for Mac computers and is the successor to Mac OS X Panther.
b)
The third major release of macOS, Apple's desktop and server operating system. Jaguar was the first Mac OS X release to publicly use its code name in marketing and advertisements.
c)
The first major release and version of macOS, Apple's desktop and server operating system and is the successor to Mac OS 9.
d)
The thirteenth major release of macOS, Apple Inc.'s desktop and server operating system for Macintosh computers and is the successor to OS X Mountain Lion.
6.
macOS Big Sur
a)
The twenty-first and current major release of Apple's macOS operating system, the successor to macOS Sonoma.
b)
The fifth major release of macOS, Apple's desktop and server operating system for Mac computers and is the successor to Mac OS X Panther.
c)
The first major release and version of macOS, Apple's desktop and server operating system and is the successor to Mac OS 9.
d)
The seventeenth release of macOS, Apple Inc.'s operating system for Macintosh computers, and is the successor to macOS Catalina.
7.
macOS Sonoma
a)
The tenth major release of macOS, Apple Inc.'s desktop and server operating system for Macintosh computers and is the successor to OS X El Capitan.
b)
The twenty-first and current major release of Apple's macOS operating system, the successor to macOS Sonoma.
c)
The thirteenth major release of macOS, Apple Inc.'s desktop and server operating system for Macintosh computers and is the successor to OS X Mountain Lion.
d)
The nineteenth major release of macOS, Apple Inc.'s operating system for Macintosh computers, and is the successor to macOS Monterey.
8.
macOS Sequoia
a)
The third major release of macOS, Apple's desktop and server operating system. Jaguar was the first Mac OS X release to publicly use its code name in marketing and advertisements.
b)
The tenth major release of macOS, Apple Inc.'s desktop and server operating system for Macintosh computers and is the successor to OS X El Capitan.
c)
The twenty-first and current major release of Apple's macOS operating system, the successor to macOS Sonoma.
d)
The thirteenth major release of macOS, Apple Inc.'s desktop and server operating system for Macintosh computers and is the successor to OS X Mountain Lion.
9.
sum
a)
=SUM(B2:B12)
b)
=A2*A3
c)
add all the numbers in a range of cells
d)
=SUM(B8:B20)*SUM(C28:C40)
10.
average
a)
=AVERAGE(A2:Q2)
b)
=B8-N9
c)
=MIN(B1:G10)
d)
return the average of its arguments
11.
max
a)
=MIN(B1:G10)
b)
=SUM(C1:W1)
c)
=SUM(B8:B20)*SUM(C28:C40)
d)
return the largest value in a set of values
12.
min
a)
=MAX(B1:B31)
b)
=B2/SUM(B10:B21)
c)
return the largest value in a set of values
d)
return the smallest value in a set of values
13.
count
a)
=SUM(C1:W1)
b)
=B8-N9
c)
=A6*SUM(C1:G10)/A2
d)
count the number of cells in a range that contains numbers
14.
vlookup
a)
add all the numbers in a range of cells
b)
looks up a value from the leftmost column of a table,and returns a value in the same row from a column you specify
c)
=SUM(A1:C10)-B8
d)
=B8-N9
15.
Formula: Add a range of numbers in cells B2:B12
a)
=SUM(C1:W1)
b)
=B8-N9
c)
return the smallest value in a set of values
d)
=SUM(B2:B12)
16.
Formula: Find the largest number in cell C14 through Z14
a)
=B2/SUM(B10:B21)
b)
=AVERAGE(A2:Q2)
c)
=A2*A3
d)
=MAX(C14:Z14)
17.
Write a formula (function) to add the range of cells C1:W1.
a)
return the largest value in a set of values
b)
=SUM(C1:W1)
c)
=MAX(B1:B31)
d)
=AVERAGE(A2:Q2)
18.
Divide B2 by the sum of the range of cells in B10 through B21
a)
=SUM(C1:W1)
b)
=AVERAGE(A2:Q2)
c)
=A6*SUM(C1:G10)/A2
d)
=B2/SUM(B10:B21)
19.
Write a formula to find the highest number in the cell range B1:B31.
a)
=B2/SUM(B10:B21)
b)
=B8-N9
c)
=MAX(B1:B31)
d)
=SUM(B8:B20)*SUM(C28:C40)
20.
Write a formula to subtract B8 from the sum of cells A1 through C10
a)
=SUM(A1:C10)-B8
b)
return the average of its arguments
c)
=SUM(S1:S10)-C10
d)
=SUM(C1:W1)
21.
Write a formula that multiplies A6 by the sum of cells C1 through G10, then divide the result by A2.
a)
=A2*A3
b)
=AVERAGE(C1:C10)
c)
=A6*SUM(C1:G10)/A2
d)
return the smallest value in a set of values
22.
Write a formula that will average the cells A2 through Q2.
a)
=SUM(A1:C10)-B8
b)
=AVERAGE(A2:Q2)
c)
=AVERAGE(C1:C10)
d)
=A6*SUM(C1:G10)/A2
23.
Write a formula to find the lowest number in the cell range B1:G10
a)
=MIN(B1:G10)
b)
=A2*A3
c)
=AVERAGE(C1:C10)
d)
=SUM(C1:W1)
24.
Write a formula to calculate the average of cells C1:C10
a)
looks up a value from the leftmost column of a table,and returns a value in the same row from a column you specify
b)
=AVERAGE(C1:C10)
c)
=A2*A3
d)
add all the numbers in a range of cells
25.
Write a formula to multiply the sum of cells B8 through B20 by the sum of C28 through C40
a)
return the largest value in a set of values
b)
=AVERAGE(A2:Q2)
c)
=SUM(A1:C10)-B8
d)
=SUM(B8:B20)*SUM(C28:C40)
26.
Write a formula to subtract C10 from the sum of the cells in the range S1 through S10.
a)
=A6*SUM(C1:G10)/A2
b)
=SUM(S1:S10)-C10
c)
=MAX(C14:Z14)
d)
looks up a value from the leftmost column of a table,and returns a value in the same row from a column you specify
27.
Write a formula that will subtract N9 from B8
a)
=SUM(C1:W1)
b)
return the average of its arguments
c)
=A6*SUM(C1:G10)/A2
d)
=B8-N9
28.
Write a formula that will calculate the cost of of 4 bags of potato chips is the cost was in A2 and the amount was in A3.
a)
=B2/SUM(B10:B21)
b)
return the largest value in a set of values
c)
=A2*A3
d)
=SUM(C1:W1)
100 %
