10.30 Archives - Page 2 of 2 - How Engineering Works

10.30

101. What is conditional formatting, and how is it used in dashboards?
102. How can you link slicers to multiple pivot tables or charts?
103. What is the purpose of using timeline slicers in dashboards?
104. How do slicers help in filtering data in charts and dashboards?
105. What are the key elements of an effective dashboard layout?
106. What is a dashboard in Excel?
107. How can pivot charts help in data analysis?
108. How can you create a pivot chart from a pivot table?
109. What are pivot charts, and how are they different from regular charts?
110. How do you format chart colors, fonts, and styles?
111. How do you add or remove chart elements such as titles, labels, and legends?
112. How can you change the data range of an existing chart?
113. How can you insert a chart in Excel?
114. What is a scatter plot and when is it useful?
115. When would you use a pie chart in Excel?
116. How is a line chart different from an area chart?
117. What is the difference between a column chart and a bar chart?
118. How do you choose the right chart type for your data?
119. What are the common types of charts available in Excel?
120. What is the purpose of using charts in Excel?
121. How can you detect and fix dates stored as text?
122. What problems occur when numbers are stored as text?
123. How do you convert numbers stored as text into numeric values?
124. How can Power Query standardize text formats automatically?
125. How can Power Query remove duplicate rows from a table?
126. How can Power Query remove blank rows or columns from data?
127. What is Power Query, and how is it useful for data cleaning?
128. How can Text to Columns help fix combined data issues?
129. What delimiters can be used in Text to Columns (e.g., comma, space, tab)?
130. How can Text to Columns split data in a single column into multiple columns?
131. Give an example of using Flash Fill to standardize names.
132. How can Flash Fill be used to clean or reformat data?
133. How can extra spaces in cells affect formulas or lookups?
134. What is the purpose of the CLEAN function in Excel?
135. How does the TRIM function help in cleaning text?
136. What is the difference between removing duplicates and filtering unique values?
137. What precautions should you take before removing duplicates?
138. How do you remove duplicates from a dataset in Excel?
139. How can duplicate values be identified in Excel?
140. What is data cleaning in Excel and why is it important?
141. How do you combine INDEX and MATCH for advanced lookups?
142. How does the MATCH function work in Excel?
143. What is the INDEX function used for in Excel?
144. How can XLOOKUP return a default value when no match is found?
145. How do you perform a vertical lookup using XLOOKUP?
146. How does the XLOOKUP function improve upon VLOOKUP?
147. What is the difference between VLOOKUP and HLOOKUP?
148. How can VLOOKUP return errors, and how can they be avoided?
149. What is the difference between approximate and exact match in VLOOKUP?
150. How do you structure a VLOOKUP formula?
151. What is the purpose of the VLOOKUP function?
152. How do logical operators like >, <, >=, <= work in Excel formulas?
153. What is the difference between AND and OR functions in logical tests?
154. Give an example of using IF with multiple conditions.
155. How do you combine the IF function with OR?
156. How do you combine the IF function with AND?
157. How can the IFS function simplify multiple nested IF statements?
158. What is the difference between IF and IFS functions?
159. How do you write a basic IF formula in Excel?
160. What is the purpose of the IF function in Excel?
161. How can you mix relative and absolute references in a formula?
162. What is an absolute cell reference in Excel?
163. What is a relative cell reference in Excel?
164. Explain the COUNT and COUNTA functions and their differences.
165. How does the AVERAGE function work in Excel?
166. How does the SUM function work, and give an example?
167. What is the difference between a formula and a function in Excel?
168. What are basic formulas in Excel and how are they written?
169. Explain the difference between ascending and descending sort.
170. How can you filter data in Excel using built-in filters?
171. How do you apply basic sorting in Excel?
172. What is conditional formatting and how can beginners use it?
173. How can you format numbers, currency, dates, and percentages in Excel?
174. Explain different formatting options such as font, color, and borders.
175. What is the purpose of cell formatting in Excel?
176. How can you insert or delete rows and columns in Excel?
177. What is the difference between active cell and selected cells?
178. How can you select an entire row, column, or a range of cells?
179. What is the difference between a row and a column in Excel?
180. What is a cell in Excel, and how is it identified?
181. How do undo and redo functions help beginners in software tools?
182. What steps should be taken to prevent accidental file deletion?
183. How can beginners avoid losing data when learning new software?
184. What are the common beginner mistakes while starting with software like Excel or Notion?
185. How can custom setups benefit advanced users over templates?
186. What are some advantages of using pre-made templates in tools like Canva or Excel?
187. When should a beginner prefer templates over custom setups?
188. Explain the difference between using templates and creating custom designs or documents.
189. What is the difference between saving a file locally and in the cloud?
190. How does cloud storage integration enhance file management in software?
191. What are the best practices for organizing files and folders in software applications?
192. Explain the concept of file management in software tools.
193. How can keyboard shortcuts improve productivity in software like Notion or Canva?
194. What are some common keyboard shortcuts in Excel, and why are they useful?
195. How does exploring a software’s UI help a beginner learn faster?
196. What are the main components of a typical software UI?
197. Explain the purpose of a user interface (UI) in software applications.
198. What are the key differences between desktop and web-based versions of software like Excel or Canva?
199. How can you identify which software is best suited for your workflow?
200. What factors should you consider when choosing the right software tool for a project?

Prev 1 2