CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: detects a text/data pattern and fills values based on examples?
A. Flash Fill
B. Excel Table
C. Solver
D. Range
Correct Answer: A
Flash Fill: detects a text/data pattern and fills values based on examples.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: automatically extends data patterns, series, or formulas into adjacent cells?
A. TEXT
B. Split
C. AutoFill
D. XLOOKUP
Correct Answer: C
AutoFill: automatically extends data patterns, series, or formulas into adjacent cells.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the small handle on a selected cell/range used to copy formulas or continue series?
A. Fill handle
B. Print Area
C. Number format
D. DATE
Correct Answer: A
Fill handle: the small handle on a selected cell/range used to copy formulas or continue series.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the tab used to select, rename, move, copy, or manage worksheets?
A. RIGHT
B. Sheet tab
C. Split
D. PivotChart
Correct Answer: B
Sheet tab: the tab used to select, rename, move, copy, or manage worksheets.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the box that displays the active cell reference and can navigate to named ranges or addresses?
A. Goal Seek
B. ROUND
C. AVERAGEIF
D. Name Box
Correct Answer: D
Name Box: the box that displays the active cell reference and can navigate to named ranges or addresses.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the area used to view or edit a cell's value or formula?
A. Drop-down list
B. Goal Seek
C. Formula bar
D. Named range
Correct Answer: C
Formula bar: the area used to view or edit a cell's value or formula.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the currently selected cell where data can be entered?
A. Text to Columns
B. Active cell
C. Fill handle
D. ROUND
Correct Answer: B
Active cell: the currently selected cell where data can be entered.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a group or block of one or more cells?
A. Named range
B. Mixed reference
C. Sort
D. Range
Correct Answer: D
Range: a group or block of one or more cells.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: the combination of column letter and row number that identifies a cell, such as B7?
A. VLOOKUP
B. Split
C. Mixed reference
D. Cell address
Correct Answer: D
Cell address: the combination of column letter and row number that identifies a cell, such as B7.
CSS - PMS - CCE - PCS - Basic Computing
MS Excel
Which Excel term, feature, function, or error best matches this description: a spreadsheet page made of rows and columns within a workbook?
A. #NAME?
B. INT
C. Worksheet
D. Timeline
Correct Answer: C
Worksheet: a spreadsheet page made of rows and columns within a workbook.
CSS - PMS - CCE - PCS - Basic Computing
Internet Basics
Which Internet-related term best matches this description: a protocol that automatically supplies IP configuration information to clients?
A. IPv4
B. Search index
C. IPv6
D. DHCP
Correct Answer: D
DHCP is a protocol that automatically supplies IP configuration information to clients.
CSS - PMS - CCE - PCS - Basic Computing
Internet Basics
Which Internet-related term best matches this description: a technique that translates addresses between network realms, commonly between private and public IPv4 networks?
A. NAT
B. Tethering
C. Wi-Fi
D. POP3
Correct Answer: A
NAT is a technique that translates addresses between network realms, commonly between private and public IPv4 networks.
CSS - PMS - CCE - PCS - Basic Computing
Internet Basics
Which Internet-related term best matches this description: a two-dimensional barcode that can encode URLs or other data?
A. QR code
B. Router
C. Peer-to-peer network
D. TCP
Correct Answer: A
QR code is a two-dimensional barcode that can encode URLs or other data.
CSS - PMS - CCE - PCS - Basic Computing
Internet Basics
Which Internet-related term best matches this description: a challenge intended to distinguish human users from automated programs?
A. Captcha
B. IPv4
C. Latency
D. HTTPS
Correct Answer: A
Captcha is a challenge intended to distinguish human users from automated programs.
CSS - PMS - CCE - PCS - Basic Computing
Internet Basics
Which Internet-related term best matches this description: authentication requiring two distinct types of evidence?
A. Ping
B. Phishing
C. Two-factor authentication
D. Router
Correct Answer: C
Two-factor authentication is authentication requiring two distinct types of evidence.
CSS - PMS - CCE - PCS - Basic Computing
Internet Basics
Which Internet-related term best matches this description: the trail of data and activity associated with a person's use of digital services?
A. Download
B. Netiquette
C. Digital footprint
D. NAT
Correct Answer: C
Digital footprint is the trail of data and activity associated with a person's use of digital services.
CSS - PMS - CCE - PCS - Basic Computing
Internet Basics
Which Internet-related term best matches this description: accepted norms for polite and responsible behavior in online communication?
A. Packet
B. Web server
C. Home page
D. Netiquette
Correct Answer: D
Netiquette is accepted norms for polite and responsible behavior in online communication.
CSS - PMS - CCE - PCS - Basic Computing
Internet Basics
Which Internet-related term best matches this description: unsolicited bulk electronic messages, especially email?
A. SSH
B. Packet
C. Spam
D. Latency
Correct Answer: C
Spam is unsolicited bulk electronic messages, especially email.
CSS - PMS - CCE - PCS - Basic Computing
Internet Basics
Which Internet-related term best matches this description: an electronic credential that binds a public key to an identity under a certificate system?
A. Digital certificate
B. Ping
C. CDN
D. Spam
Correct Answer: A
Digital certificate is an electronic credential that binds a public key to an identity under a certificate system.
CSS - PMS - CCE - PCS - Basic Computing
Internet Basics
Which Internet-related term best matches this description: a protocol that protects data in transit with cryptographic security?
A. TLS
B. Web page
C. Bandwidth
D. QR code
Correct Answer: A
TLS is a protocol that protects data in transit with cryptographic security.