1
Q
What is a spreadsheet?
A
A spreadsheet is a two-dimensional table split into rows and columns used to organize and analyze data.
2
Q
Define a cell and give an example of a cell address.
A
A cell is an individual unit in a spreadsheet identified by its column and row, e.g., B3.
3
Q
What are the three types of data a cell can contain?
A
A number, text (label), or a formula.
4
Q
What is a formula in Excel?
A
A formula is an expression that performs calculations on values in a spreadsheet, starting with ‘=’.
5
Q
What does .csv stand for?
A
Comma Separated Values.
6
Q
What is a label in a spreadsheet?
A
Text entered in a cell, often used for headings or descriptions.
7
Q
What is the default file extension for Excel workbooks?
A
.xlsx
8
Q
What is the difference between a workbook and a worksheet?
A
A workbook is the entire file; a worksheet is a single tab within the workbook.
9
Q
What is the purpose of gridlines in Excel?
A
Gridlines help visually separate cells for easier reading.
10
Q
What is the function of the Page Layout tab?
A
It allows you to adjust page size, orientation, margins, and print settings.
11
Q
Explain the difference between a label and a formula.
A
A label is text for identification; a formula performs calculations.
12
Q
How do you import a .csv file into Excel?
A
Use Data tab > Get & Transform Data > From Text/CSV, then select the file and load it.
13
Q
Describe how to change page orientation in Excel.
A
Go to Page Layout tab > Orientation > select Portrait or Landscape.
14
Q
What is the purpose of headers and footers?
A
To add information like page numbers, date, or filename to printed sheets.
15
Q
Explain absolute vs relative cell referencing.
A
Absolute uses $ signs (e.g., $A$1) to fix a cell; relative adjusts references when copied.
16
Q
What is a named range?
A
A descriptive name assigned to a cell or range for easier reference in formulas.
17
Q
How do you display formulas in a worksheet?
A
Go to Formulas tab > Show Formulas.
18
Q
What is the difference between SUM and AVERAGE functions?
A
SUM adds values; AVERAGE calculates the mean of values.
19
Q
What does the Freeze Panes feature do?
A
It locks rows or columns so they remain visible while scrolling.
20
Q
What is the Wrap Text feature used for?
A
It makes text fit within a cell by displaying it on multiple lines.
21
Q
How do you freeze panes so that the first row and column remain visible?
A
Select cell B2, then go to View tab > Freeze Panes > Freeze Panes.
22
Q
Explain how to create a named range and why it is useful.
A
Select cells, go to Formulas tab > Define Name, enter a name. Useful for easier formula writing.
23
Q
Discuss the advantages of using functions like SUM instead of manual addition.
A
Functions are faster, reduce errors, and update automatically when data changes.
24
Q
How would you protect a worksheet with a password?
A
Go to Review tab > Protect Sheet, set a password and select allowed actions.
25
How do you insert a header with the filename and date?
Go to Page Layout > Header & Footer > Insert File Name and Date.
26
Explain how to hide and unhide rows in Excel.
Right-click the row header > Hide; to unhide, select adjacent rows, right-click > Unhide.
27
What is the difference between splitting and freezing panes?
Splitting divides the window into sections; freezing locks rows/columns in place.
28
Scenario: A company wants to display the filename and page number in the footer of a printed spreadsheet. Explain the steps.
Go to Page Layout > Header & Footer > Footer, insert File Name and Page Number fields.
29
Scenario: Design a spreadsheet to calculate 3^x for any given x. Explain the formula used.
Use =POWER(3,x) where x is the cell reference.
30
Scenario: A user wants to hide certain rows without deleting them. Describe the process.
Select rows, right-click > Hide. To unhide, select adjacent rows, right-click > Unhide.
31
Scenario: Explain how to split a window so two sections of the same sheet can be viewed simultaneously.
Go to View tab > Split. Position the split where needed.
32
Scenario: A spreadsheet needs to calculate total and average sales. Which functions would you use?
Use SUM for total and AVERAGE for mean.
33
Scenario: How do you insert a new column between columns B and C?
Right-click column C header > Insert.
34
Scenario: A manager wants to protect cells containing formulas. Explain the steps.
Unlock other cells, then Review tab > Protect Sheet with password.
35
Explain the difference between INT and ROUND functions.
INT removes decimals; ROUND adjusts to specified decimal places.
36
How do you apply conditional formatting to highlight values greater than 100?
Select range, go to Home > Conditional Formatting > Greater Than, enter 100.
37
Explain why absolute referencing is important in times tables.
It ensures the reference cell remains fixed when copying formulas.
38
How do you insert a custom header with your name and date?
Go to Page Layout > Header & Footer > Custom Header, type name and insert date field.
39
Explain the purpose of the AutoSum feature.
It quickly inserts SUM function for selected cells.
40
How do you merge cells A1 to C1 and center the text?
Select cells, go to Home > Merge & Center.
41
Explain the difference between CONCAT and CONCATENATE.
CONCAT is newer and supports ranges; CONCATENATE is older and requires individual arguments.
42
What does =SUM(A1:A10) do?
Adds all numeric values in cells A1 to A10.
43
What does =AVERAGE(B1:B10) do?
Calculates the average of values in B1 to B10.
44
What does =COUNT(C1:C20) do?
Counts the number of numeric values in C1 to C20.
45
What does =COUNTA(D1:D20) do?
Counts all non-empty cells in D1 to D20.
46
What does =COUNTBLANK(E1:E20) do?
Counts the number of blank cells in E1 to E20.
47
What does =ROUND(F2,2) do?
Rounds the value in F2 to 2 decimal places.
48
What does =IF(G2>50,'Pass','Fail') do?
Checks if G2 is greater than 50; returns 'Pass' if true, else 'Fail'.
49
What does =IFS(H2>=80,'A',H2>=60,'B',TRUE,'C') do?
Assigns grades based on H2: A if >=80, B if >=60, else C.
50
What does =AND(I2>=60,I2<=80) do?
Checks if I2 is between 60 and 80.
51
What does =OR(J2<40,J2>90) do?
Checks if J2 is less than 40 or greater than 90.
52
What does =IFERROR(K2/L2,'Error') do?
Divides K2 by L2; returns 'Error' if division fails.
53
What does =VLOOKUP(101,A2:D50,3,FALSE) do?
Looks for 101 in first column of A2:D50 and returns value from 3rd column.
54
What does =HLOOKUP('Code',A1:Z2,2,FALSE) do?
Searches for 'Code' in first row of A1:Z2 and returns value from 2nd row.
55
What does =XLOOKUP(M2,MRange,NRange,'Not Found') do?
Finds M2 in MRange and returns corresponding value from NRange.
56
What does =INDEX(O2:Q10,3,2) do?
Returns value from 3rd row and 2nd column of range O2:Q10.
57
What does =MATCH('Beta',R2:R20,0) do?
Returns position of 'Beta' in range R2:R20.
58
What does =CONCATENATE(S2,' ',T2) do?
Combines text in S2 and T2 with a space.
59
What does =LEFT(U2,3) do?
Extracts first 3 characters from text in U2.
60
What does =RIGHT(V2,5) do?
Extracts last 5 characters from text in V2.
61
What does =MID(W2,3,4) do?
Extracts 4 characters starting from position 3 in W2.
62
What does =LEN(X2) do?
Returns number of characters in X2.
63
What does =FIND(':',Y2) do?
Returns position of colon in text in Y2.
64
What does =SEARCH('a',Z2) do?
Returns position of 'a' in text in Z2 (case-insensitive).
65
What does =SUBSTITUTE(AA2,'None','') do?
Replaces 'None' with blank in AA2.
66
What does =TEXT(AB2,'$#,##0.00') do?
Formats number in AB2 as currency.
67
What does =SUMIFS(SalaryRange,GenderRange,'Male',StatusRange,'Full') do?
Calculates total salary for male full-time employees.
68
What does =AVERAGEIFS(SalaryRange,GenderRange,'Female',StatusRange,'Part') do?
Calculates average salary for female part-time employees.
69
What does =MAXIFS(SalaryRange,StatusRange,'Full') do?
Returns maximum salary for full-time employees.
70
What does =MINIFS(SalaryRange,StatusRange,'Part') do?
Returns minimum salary for part-time employees.
71
What does =ISTEXT(AC2) do?
Checks if AC2 contains text.
72
What does =ISNUMBER(AD2) do?
Checks if AD2 contains a number.
73
What does =ISBLANK(AE2) do?
Checks if AE2 is blank.
74
What does =ROUNDUP(AF2,1) do?
Rounds AF2 up to 1 decimal place.
75
What does =ROUNDDOWN(AG2,2) do?
Rounds AG2 down to 2 decimal places.
76
What does =POWER(AH2,3) do?
Raises value in AH2 to the power of 3.
77
What does =INT(AI2) do?
Removes decimal part of AI2 and returns integer.
78
What does =TRIM(AJ2) do?
Removes extra spaces from text in AJ2.
79
What does =PROPER(AK2) do?
Capitalises first letter of each word in AK2.
80
What does =UPPER(AL2) do?
Converts text in AL2 to uppercase.
81
What does =LOWER(AM2) do?
Converts text in AM2 to lowercase.
82
What does =REPLACE(AN2,2,3,'XYZ') do?
Replaces 3 characters starting at position 2 in AN2 with 'XYZ'.
83
What does =REPT(AO2,3) do?
Repeats text in AO2 three times.
84
What does =CHAR(65) do?
Returns character represented by ASCII code 65 (A).
85
What does =CODE(AP2) do?
Returns ASCII code of first character in AP2.
86
What does =NOW() do?
Returns current date and time.
87
What does =TODAY() do?
Returns current date.
88
What does =EDATE(AQ2,3) do?
Returns date that is 3 months after date in AQ2.
89
What does =NETWORKDAYS(AR2,AS2) do?
Returns number of working days between AR2 and AS2.
90
What does =WORKDAY(AT2,10) do?
Returns date that is 10 working days after date in AT2.
91
What does =IF(OR(AU2>100,AV2<50),'Check','OK') do?
Returns 'Check' if AU2>100 or AV2<50, else 'OK'.
92
What does =LEFT(A2,3) do?
Extracts the first 3 characters from cell A2.
93
What does =MID(B2,2,5) do?
Extracts 5 characters starting from position 2 in cell B2.
94
What does =FIND(',',C2) do?
Returns the position of the first comma in cell C2.
95
What does =LEN(D2) do?
Returns the number of characters in cell D2.
96
What does =UPPER(E2) do?
Converts text in E2 to uppercase.
97
What does =LOWER(F2) do?
Converts text in F2 to lowercase.
98
What does =EXACT(G2,H2) do?
Checks if text in G2 and H2 are exactly the same, including case.
99
What does =ISTEXT(A5) do?
Checks if cell A5 contains text.
100
What does =ISNUMBER(B5) do?
Checks if cell B5 contains a number.
101
What does =ISBLANK(C5) do?
Checks if cell C5 is blank.
102
What does =CODE(D2) do?
Returns the ASCII code of the first character in D2.
103
What does =CHAR(65) do?
Returns the character represented by ASCII code 65 (A).
104
What does =DEC2BIN(78) do?
Converts decimal 78 to binary (1001110).
105
What does =DEC2HEX(78) do?
Converts decimal 78 to hexadecimal (4E).
106
What does =BIN2DEC(11111111) do?
Converts binary 11111111 to decimal (255).
107
What does =BIN2HEX(11111111) do?
Converts binary 11111111 to hexadecimal (FF).
108
What does =HEX2BIN('FE') do?
Converts hexadecimal FE to binary (11111110).
109
What does =HEX2DEC('FE') do?
Converts hexadecimal FE to decimal (254).
110
What does =DATE(2024,5,16) do?
Creates a date value for 16 May 2024.
111
What does =TIME(17,25,23) do?
Creates a time value for 17:25:23 (5:25 PM).
112
What does =WEEKDAY(A2) do?
Returns a number (1-7) representing the day of the week for the date in A2.
113
What does =DAY(B2) do?
Returns the day part of the date in B2.
114
What does =MONTH(C2) do?
Returns the month part of the date in C2.
115
What does =YEAR(D2) do?
Returns the year part of the date in D2.
116
What does =DATEDIF(A2,B2,'D') do?
Returns the number of days between dates in A2 and B2.
117
What does =DATEDIF(A2,B2,'M') do?
Returns the number of months between dates in A2 and B2.
118
What does =DATEDIF(A2,B2,'Y') do?
Returns the number of years between dates in A2 and B2.
119
What does =HOUR(E2) do?
Returns the hour part of the time in E2.
120
What does =MINUTE(F2) do?
Returns the minute part of the time in F2.
121
What does =SECOND(G2) do?
Returns the second part of the time in G2.
122
What is Data Validation in Excel?
A feature that restricts the type of data or values entered into a cell.
123
How do you restrict input to whole numbers between 0 and 10?
Use Data Validation: Allow = Whole Number, Minimum = 0, Maximum = 10.
124
What does an Input Message in validation do?
Displays a message to guide the user before entering data.
125
What does an Error Alert in validation do?
Shows a warning or stops invalid data entry.
126
What is Conditional Formatting?
A feature that changes cell appearance based on conditions.
127
How do you apply a rule to highlight cells greater than 100?
Use Conditional Formatting: Format cells > Greater Than > enter 100.
128
What does Format Cells > Number do?
Sets numeric display format, including decimal places.
129
What does Format Cells > Currency do?
Displays numbers as currency with a symbol.
130
What does Format Cells > Percentage do?
Displays numbers as percentages.
131
What does Format Cells > Alignment do?
Controls text alignment (left, center, right) and orientation.
132
What does Format Cells > Font do?
Changes font style, size, and color.
133
What does Format Cells > Border do?
Adds borders around cells.
134
What does Format Cells > Fill do?
Adds background color or patterns to cells.
135
What does Conditional Formatting > Manage Rules do?
Allows editing and managing existing formatting rules.
136
What does the EXACT function check?
Checks if two text strings are exactly the same, including case.
137
What does the TEXT function do?
Formats a number or date as text using a specified format.
138
What does the TRIM function do?
Removes extra spaces from text.
139
What does the PROPER function do?
Capitalises the first letter of each word in text.
140
What does the SUBSTITUTE function do?
Replaces occurrences of specified text within a string.
141
What does the REPLACE function do?
Replaces part of a text string based on position and length.
142
What does the CONCAT function do?
Joins multiple text strings into one.
143
What does the EXACT function ignore?
It does not ignore case; it checks case sensitivity.
144
What does the WEEKDAY function return?
Returns a number from 1 to 7 representing the day of the week.
145
What does the NETWORKDAYS function do?
Returns the number of working days between two dates.
146
What does the WORKDAY function do?
Returns a date that is a specified number of working days from a start date.
147
What does the TEXT function with 'dd mmmm yyyy' format do?
Displays a date as day, full month name, and year.
148
What does the TEXT function with 'hh:mm:ss' format do?
Displays time in hours, minutes, and seconds.
149
What does =LEN(A2) do?
Returns the number of characters in cell A2.
150
What does =LEFT(B2,4) do?
Extracts the first 4 characters from cell B2.
151
What does =MID(C2,3,2) do?
Extracts 2 characters starting from position 3 in cell C2.
152
What does =ROUND(D2,2) do?
Rounds the value in D2 to 2 decimal places.
153
What does =IF(E2>50,'Pass','Fail') do?
Checks if E2 is greater than 50; returns 'Pass' if true, else 'Fail'.
154
What does =COUNT(F2:F20) do?
Counts numeric values in the range F2:F20.
155
What does =AVERAGE(G2:G10) do?
Calculates the average of values in G2:G10.
156
What does =VLOOKUP(101,A2:D50,3,FALSE) do?
Looks for 101 in the first column of A2:D50 and returns value from the 3rd column.
157
What does =INDEX(A2:C10,3,2) do?
Returns the value from 3rd row and 2nd column of range A2:C10.
158
What does =MATCH('Beta',A2:A20,0) do?
Returns the position of 'Beta' in range A2:A20.
159
What is Data Validation in Excel?
A feature that restricts the type of data entered in a cell.
160
How do you restrict input to whole numbers between 1 and 10?
Use Data Validation: Allow Whole Number, Minimum=1, Maximum=10.
161
What does an Input Message do in validation?
Displays a message to guide the user before entering data.
162
What does an Error Alert do in validation?
Shows a warning or prevents invalid data entry.
163
What is the purpose of a test plan in spreadsheets?
To check that formulae and validation rules work as expected.
164
What is normal data in testing?
Data within expected range or format.
165
What is extreme data in testing?
Data at the upper or lower limits of the allowed range.
166
What is abnormal data in testing?
Data outside the allowed range or invalid format.
167
Why do we test formulae with different data types?
To ensure formulae handle all valid and invalid inputs correctly.
168
What does 'Validation error message' mean?
It indicates that entered data does not meet validation rules.
169
What does a text filter do in Excel?
Filters rows based on text criteria.
170
What does a number filter do in Excel?
Filters rows based on numeric conditions.
171
What does a date filter do in Excel?
Filters rows based on date conditions.
172
What does 'Custom AutoFilter' allow you to do?
Apply advanced filtering using multiple conditions.
173
What does the AND operator mean in filtering?
Both conditions must be true for a row to be displayed.
174
What does the OR operator mean in filtering?
At least one condition must be true for a row to be displayed.
175
What does 'Does Not Contain' filter do?
Excludes rows containing specified text.
176
What does 'Contains' filter do?
Includes rows containing specified text.
177
What does sorting data do?
Arranges data in ascending or descending order.
178
What is the difference between ascending and descending sort?
Ascending goes from smallest to largest; descending goes from largest to smallest.
179
What is a pie chart used for?
To show parts of a whole as percentages.
180
What is a bar chart used for?
To compare differences between items.
181
What is a line graph used for?
To show trends over time or between variables.
182
What does 'Add Chart Element' allow you to do?
Add titles, labels, and other elements to a chart.
183
What does 'Axis Titles' do in a chart?
Adds labels to the X and Y axes.
184
What does 'Data Labels' do in a chart?
Displays values on the chart for each data point.
185
What is a pivot table?
A tool to summarize and analyze data in a table format.
186
What does the Rows area in a pivot table do?
Displays data grouped by row fields.
187
What does the Values area in a pivot table do?
Shows summarized data like sums or averages.
188
What does the Columns area in a pivot table do?
Displays data grouped by column fields.
189
What is the purpose of a pivot chart?
To visualize pivot table data in a graphical format.
190
What does exporting to PDF do?
Saves the spreadsheet as a PDF document for easy sharing.
191
Why would you export a spreadsheet to .csv format?
To share data in a simple text format compatible with many applications.
192
What does =PROPER(A2) do?
Capitalizes the first letter of each word in A2.
193
What does =TRIM(B2) do?
Removes extra spaces from text in B2.
194
What does =TEXT(C2,'dd mmmm yyyy') do?
Formats a date in C2 as day, full month name, and year.
195
What does =NETWORKDAYS(D2,E2) do?
Returns the number of working days between two dates.
196
What does =WORKDAY(F2,10) do?
Returns the date that is 10 working days after F2.
197
What does =SEARCH('a',G2) do?
Finds the position of 'a' in text in G2 (case-insensitive).
198
What does =SUBSTITUTE(H2,'None','') do?
Replaces 'None' with blank in H2.
199
What does =REPLACE(I2,2,3,'XYZ') do?
Replaces 3 characters starting at position 2 in I2 with 'XYZ'.
200
What does =CONCAT(J2,K2) do?
Joins text from J2 and K2 into one string.
201
What does =ROUNDUP(L2,1) do?
Rounds L2 up to 1 decimal place.
202
What does =ROUNDDOWN(M2,2) do?
Rounds M2 down to 2 decimal places.
203
What does =POWER(N2,3) do?
Raises the value in N2 to the power of 3.
204
What does =INT(O2) do?
Removes decimal part of O2 and returns integer.
205
What does =CHAR(65) do?
Returns the character represented by ASCII code 65 (A).
206
What does =CODE(P2) do?
Returns the ASCII code of the first character in P2.
207
What does =NOW() do?
Returns the current date and time.
208
What does =TODAY() do?
Returns the current date.
209
What does =EDATE(Q2,3) do?
Returns the date that is 3 months after Q2.
210
What does =DATEDIF(R2,S2,'D') do?
Returns the number of days between R2 and S2.
211
What does =DATEDIF(R2,S2,'M') do?
Returns the number of months between R2 and S2.
212
What does =DATEDIF(R2,S2,'Y') do?
Returns the number of years between R2 and S2.
CIE A level IT 9626
flashcards
Decks in class (12)
# Cards
-
Unit 1 Data Processing and Information111
-
Unit 2 Hardware and Software98
-
Unit 3 Monitoring and Control86
-
Unit 4 Algorithms and Flowcharts42
-
Unit 5 eSecurity49
-
Unit 6 Digital Divide50
-
Unit 7 Expert Systems50
-
Unit 8 Spreadsheets212
-
Unit 9 Modelling78
-
Unit 10 Databases and File Concepts114
-
Unit 11 Video and Audio Editing89
-
Key words189
