A
What does "URL" stand for?
Uniform Resource Locator
Which programming language is often used for creating web pages?
HTML (Hypertext Markup Language)
What is the purpose of a firewall in computer security?
Protects the computer from threats and untrusted external networks
How do you freeze rows or columns in Excel to keep them visible while scrolling?
You can use the "Freeze Panes" feature under the "View" tab to freeze rows or columns in Excel.
What does the term "cell reference" mean in Excel?
Is a combination of the column letter and row number that identifies a specific cell, such as "A1" or "B2."
What function in Excel is used to add up a range of cells?
SUM formula
What is the purpose of the CONCATENATE function in Excel/Google Sheets?
The CONCATENATE function is used to combine multiple text strings into a single string.
What is the purpose of the IF function in Excel/Google Sheets?
The IF function is used for conditional logic. It returns one value if a condition is true and another value if the condition is false.
How can you find and replace data in Excel/Google Sheets?
CTRL+F or you can use the "Find & Replace" feature, typically located under the "Home" tab in Excel and the "Edit" menu in Google Sheets.
What does the COUNTIF function do in Excel/Google Sheets?
The COUNTIF function counts the number of cells within a range that meet a specified condition.
How do you protect a sheet in Excel/Google Sheets with a password?
In Excel, you can go to the "Review" tab and choose "Protect Sheet," then set a password. In Google Sheets, click on "Protect sheets and ranges" under the "Data" tab.
What is the difference between COUNT and COUNTA formulas in Excel?
COUNT counts the number of cells containing numbers only, while COUNTA counts the number of cells containing numbers/text
What does the MATCH formula return as a result?
Row Number
What does the INDEX formula return as a result?
The content of a cell specified by row and column number
What does the INDIRECT formula
The content of the cell specified by the cell name